class CreateBloggerDatas < ActiveRecord::Migration
  def self.up
    create_table :blogger_datas do |t|
      t.column :crawl_id, :integer
      
      t.column :full_name, :string
      t.column :first_name, :string
      t.column :last_name, :string
      
      t.column :gender, :string
      t.column :email, :string
      
      t.column :occupation, :string
      t.column :role, :string
      
      t.column :country, :string
      t.column :locale_country, :string
      t.column :state, :string
      t.column :locality, :string
      
      t.column :last_update, :datetime
      # t.timestamps
    end
    add_index :blogger_datas, :crawl_id
  end
  
  def self.down
    remove_index :blogger_datas, :crawl_id
    drop_table :blogger_datas
  end
end
